SUPPORT / SAMPLES & SAS NOTES
Problem Note 63178: The DEFER=YES option is ignored in SAS/ACCESS® Interface to Vertica when the LIBNAME statement option CONNECTION=UNIQUE is also specified
 |  |  |  |  |
With SAS/ACCESS Interface to Vertica, the LIBNAME statement option DEFER=YES is ignored when the LIBNAME statement also contains the CONNECTION=UNIQUE option.
In this situation, connections are opened immediately after you assign the libref and are not deferred to a later time. As a result, the maximum number of connections to Vertica is reached and no further connections can be opened.
An error message similar to the following is then written to the log:
ERROR: CLI error trying to establish connection: [Vertica][VerticaDSII] (160) Connection attempt failed: FATAL 4060: New session rejected due to limit
ERROR: Error in the LIBNAME statement.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to Vertica | Microsoft® Windows® for x64 | 9.4 TS1M5 | 9.4 TS1M5 |
| 64-bit Enabled AIX | 9.4 TS1M5 | 9.4 TS1M5 | ||
| 64-bit Enabled Solaris | 9.4 TS1M5 | 9.4 TS1M5 | ||
| HP-UX IPF | 9.4 TS1M5 | 9.4 TS1M5 | ||
| Linux for x64 | 9.4 TS1M5 | 9.4 TS1M5 | ||
| Solaris for x64 | 9.4 TS1M5 | 9.4 TS1M5 | ||